Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

DataServer utilities

Progress supports a number of utilities that allow you to create and maintain an MS SQL dataserver.

To see all available DataServer utilities, choose DataServer MS SQL Server Utilities. the DataServer utilities are described in Table 7–2.

Table 7–2: DataServer utilities

Utility	Description
Create DataServer Schema...	Creates a schema image in the schema holder for the MS SQL Server database.
Update/Add Table Definitions...	Updates the schema holder to reflect any changes that you make to data definitions.
Verify Table Definition...	Makes sure that the data definitions in the schema holder match your data source data definitions.
Edit Connection Information...	Changes connection information or the logical database name for an MS SQL Server database.
Change DataServer Schema Code Page...	Changes the code page in the schema holder associated with the MS SQL Server database.
Delete DataServer Schema...	Deletes a schema image from the schema holder.
Schema Migration Tools	Accesses utilities for migrating an OpenEdge database to an MS SQL Server database, for incrementally migrating a schema to MS SQL Server, and adjusting the schema image.

When you access a DataServer utility (as you will do in the tutorials that follow this section), the following dialog box might appear before the utility opens:

To accept the user ID and password combination that you supplied in the User ID and Password dialog box, choose OK. If you want to change them, or they were never specified, enter a user ID and password with the privileges required for creating and updating a schema holder. See the "Permission requirements" section for information on privileges.